bug? Coercing float8 to text sticks number in the middle of a date

Поиск
Список
Период
Сортировка
От Donald Jackson
Тема bug? Coercing float8 to text sticks number in the middle of a date
Дата
Msg-id l0311070db37b67d19062@[132.183.120.67]
обсуждение исходный текст
Список pgsql-bugs
The function:

CREATE FUNCTION zfin_comments(text) RETURNS text AS
'select lod::text || analysis_type::text
AS comments FROM markers WHERE marker_id = $1;'
LANGUAGE 'SQL';

The output:

ssr_db=> select marker_id, lod, analysis_type, zfin_comments(marker_id)
from markers;
marker_id|  lod|analysis_type|zfin_comments
---------+-----+-------------+---------------------------------------
Z8551    |19.27|final        |Fri Dec 31 19:00:19.27 1999 ESTfinal
Z8554    |13.72|final        |Fri Dec 31 19:00:13.72 1999 ESTfinal
Z8563    |18.96|final        |Fri Dec 31 19:00:18.96 1999 ESTfinal
Z8574    |18.96|final        |Fri Dec 31 19:00:18.96 1999 ESTfinal
Z8602    |20.77|final        |Fri Dec 31 19:00:20.77 1999 ESTfinal
Z8604    |17.79|final        |Fri Dec 31 19:00:17.79 1999 ESTfinal
Z8613    |17.16|final        |Fri Dec 31 19:00:17.16 1999 ESTfinal
...

Apparently, when I try to force the float8 value into text
it ends up as seconds in a datetime?  I looked for a function to convert
float to text, but found none...

thanks!

Don Jackson



В списке pgsql-bugs по дате отправления:

Предыдущее
От: "C. Arthur Venable III"
Дата:
Сообщение: 10% off custom web design
Следующее
От: "Mark Wright"
Дата:
Сообщение: Bug found in beta version